<?php
//======================================================================================
// Function: Connect to MSSQL DB
//======================================================================================

	// $serverName = "JJ-HOME\MSSQL_1";
	
	// $connectionInfo = array( "Database"=>"reeft_db", "UID"=>"sa", "PWD"=>"costello" );
	
	// $conn = sqlsrv_connect( $serverName, $connectionInfo);
	
	// if( $conn === false ) {
		 // die( print_r( sqlsrv_errors(), true));
	// }
	
	
	$server = "JJ-HOME\MSSQL_1";
	$user = "sa";
	$pwd = "costello";
	$database = "reeft_db";

	try {
	 $conn = new PDO( "sqlsrv:Server=$server;Database=$database", $user, $pwd );
	} catch ( Exception $e ) {
	 die( print_r( $e->getMessage() ) );
	}
	
	


?>